﻿CREATE TABLE [Reporting].[ErrorType]
(
	[ErrorTypeID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [REPORTING_ErrorType_ErrorTypeID] PRIMARY KEY,
	[Enum] NVARCHAR(250) NOT NULL CONSTRAINT [REPORTING_ErrorType_Enum] UNIQUE, 
	[EnumDesc] NVARCHAR(500) NOT NULL CONSTRAINT [REPORTING_ErrorType_Desc] DEFAULT ('NONE'),
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [REPORTING_ErrorType_CreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [REPORTING_ErrorType_DateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [REPORTING_ErrorType_VersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [REPORTING_ErrorType_VersionDate] DEFAULT GETDATE()
)